Introduction of Problem Domain and Dataset
This project is about the vaccinations of COVID-19 vaccines in the US. Given that the Delta variant is causing a new surge of COVID-19 cases, it is key that all people get their vaccination as soon as possible. We are eager to know how people of different states react to vaccination. By breaking down the vaccinated population by state, it would be easier to create targeting incentives, promoting vaccination to fight against the more transmissible Delta variant. Our data set is downloaded from the CDC website and contains information including the amount of vaccines distributed to and administered in each state over the course of 228 days, from 12/20/2020 to 08/04/2021.
Summary Information
For the summary, we included the following information:
- The column names, including:
date, location, total_vaccinations, total_distributed, people_vaccinated, people_fully_vaccinated_per_hundred, total_vaccinations_per_hundred, people_fully_vaccinated, people_vaccinated_per_hundred, distributed_per_hundred, daily_vaccinations_raw, daily_vaccinations, daily_vaccinations_per_million, share_doses_used, DEM, REP, usa_state, usa_state_code, percent_democrat
- the total number of vaccinations nationwide as of:
318812620
- the state with the highest percentage of fully vaccinated population as of 08/04/2021:
Vermont
- the state with the highest number of vaccination distribution as of 08/04/2021:
California
- the number of people fully vaccinated in Washington state as of 08/04/2021:
4409114
Aggregate Table
Below is a table that summarizes the number of average daily vaccinations and what day in the week has the most vaccinations in each state.
| Location | Political Stance | Most Vaccination Weekday | Daily Average Vaccination | Percentage of Daily Vaccinated Population | Fully-Vaccinated Population | Total Vaccinations |
|---|---|---|---|---|---|---|
| Vermont | DEM | Sunday | 4163.9755 | 0.6681 | 422436 | 875208 |
| Massachusetts | DEM | Saturday | 43987.2500 | 0.6364 | 4420802 | 9177481 |
| Connecticut | DEM | Friday | 21867.1912 | 0.6155 | 2264139 | 4612302 |
| Puerto Rico | NA | Thursday | 19196.8922 | 0.6010 | 1920091 | 3990725 |
| District of Columbia | DEM | Sunday | 4291.7843 | 0.6010 | 388214 | 905336 |
| Rhode Island | DEM | Friday | 6352.7108 | 0.5985 | 653856 | 1335521 |
| Hawaii | DEM | Friday | 8286.7598 | 0.5892 | 760225 | 1723982 |
| Maine | DEM | Friday | 7953.2843 | 0.5872 | 860804 | 1677415 |
| Maryland | DEM | Wednesday | 34824.0980 | 0.5741 | 3573644 | 7250347 |
| New Jersey | DEM | Saturday | 50111.7353 | 0.5647 | 5213483 | 10443839 |
| New Mexico | DEM | Friday | 11885.6029 | 0.5646 | 1205059 | 2502898 |
| Washington | DEM | Sunday | 43396.4363 | 0.5566 | 4409114 | 9048440 |
| New Hampshire | DEM | Thursday | 7591.0588 | 0.5532 | 794914 | 1599189 |
| California | DEM | Saturday | 218876.0490 | 0.5525 | 21010034 | 45467015 |
| Pennsylvania | DEM | Saturday | 70197.8971 | 0.5482 | 6743072 | 14662319 |
| Virginia | DEM | Friday | 46803.6912 | 0.5440 | 4674811 | 9738560 |
| Oregon | DEM | Sunday | 22835.2206 | 0.5324 | 2369063 | 4762995 |
| Delaware | DEM | Friday | 5244.7549 | 0.5296 | 515850 | 1096340 |
| Colorado | DEM | Sunday | 30807.6471 | 0.5227 | 3148013 | 6509188 |
| Illinois | DEM | Saturday | 65641.9314 | 0.5222 | 6184160 | 13737959 |
| Minnesota | DEM | Saturday | 29157.1863 | 0.5110 | 3043718 | 6110306 |
| Wisconsin | DEM | Saturday | 29667.9608 | 0.5069 | 3024706 | 6189517 |
| Florida | REP | Saturday | 108691.1912 | 0.4953 | 10567995 | 22806443 |
| Iowa | REP | Saturday | 14996.1127 | 0.4734 | 1572078 | 3157898 |
| Nebraska | REP | Thursday | 9214.2990 | 0.4720 | 961636 | 1954156 |
| Michigan | DEM | Saturday | 47120.1225 | 0.4716 | 4895367 | 9840190 |
| Arizona | DEM | Thursday | 34336.8922 | 0.4566 | 3309350 | 7146081 |
| Ohio | REP | Saturday | 53081.6716 | 0.4531 | 5458126 | 11140551 |
| Nevada | DEM | Saturday | 14374.6961 | 0.4512 | 1378022 | 2994091 |
| Alaska | REP | Saturday | 3258.2990 | 0.4498 | 334266 | 700531 |
| Kentucky | REP | Friday | 20108.5980 | 0.4488 | 2049739 | 4234268 |
| Kansas | REP | Saturday | 12970.2255 | 0.4446 | 1324216 | 2724194 |
| Texas | REP | Friday | 131320.9314 | 0.4417 | 12810625 | 27700931 |
| South Dakota | REP | Friday | 3955.7745 | 0.4412 | 416897 | 855676 |
| North Carolina | REP | Wednesday | 46974.6029 | 0.4390 | 4611928 | 9794429 |
| Utah | REP | Saturday | 14385.6961 | 0.4345 | 1446522 | 3029907 |
| Indiana | REP | Saturday | 29002.8529 | 0.4262 | 2990310 | 6108426 |
| Missouri | REP | Saturday | 26256.0441 | 0.4256 | 2554854 | 5518017 |
| Montana | REP | Friday | 4584.3627 | 0.4225 | 475041 | 977293 |
| Oklahoma | REP | Friday | 16355.4069 | 0.4099 | 1602871 | 3494346 |
| South Carolina | REP | Sunday | 21401.5098 | 0.4055 | 2102925 | 4446983 |
| North Dakota | REP | Friday | 3070.0245 | 0.3987 | 306479 | 665764 |
| Georgia | DEM | Friday | 43001.1324 | 0.3971 | 4106222 | 8942802 |
| Arkansas | REP | Saturday | 12042.5147 | 0.3969 | 1118090 | 2497552 |
| Tennessee | REP | Saturday | 27224.5588 | 0.3920 | 2684149 | 5805067 |
| West Virginia | REP | Friday | 6792.2892 | 0.3842 | 700616 | 1488957 |
| Louisiana | REP | Friday | 17431.2451 | 0.3767 | 1727145 | 3698745 |
| Wyoming | REP | Friday | 2114.1275 | 0.3638 | 212447 | 447749 |
| Alabama | REP | Thursday | 17490.6863 | 0.3545 | 1696031 | 3646234 |
| Idaho | REP | Sunday | 6593.6373 | 0.3545 | 670821 | 1380947 |
| Mississippi | REP | Wednesday | 10459.2696 | 0.3526 | 1035252 | 2188235 |
| New York State | NA | Saturday | 110350.9118 | NA | 11165792 | 23091118 |
| Long Term Care | NA | Friday | 34092.4755 | NA | NA | 7906639 |
| Veterans Health | NA | Saturday | 25556.6127 | NA | 2737936 | 5440303 |
| Dept of Defense | NA | Sunday | 21337.8971 | NA | 1975555 | 4492370 |
| Indian Health Svc | NA | Saturday | 7014.6373 | NA | 684170 | 1499373 |
| Guam | NA | Friday | 978.5441 | NA | 99024 | 203414 |
| Bureau of Prisons | NA | Thursday | 916.1176 | NA | 100269 | 201551 |
| Virgin Islands | NA | Wednesday | 416.4657 | NA | 37870 | 85839 |
| Northern Mariana Islands | NA | Wednesday | 286.1422 | NA | 29848 | 62095 |
| Federated States of Micronesia | NA | Wednesday | 274.5637 | NA | 29544 | 56435 |
| American Samoa | NA | Wednesday | 247.2304 | NA | 24042 | 52559 |
| Marshall Islands | NA | Sunday | 175.8873 | NA | 17505 | 36520 |
| Republic of Palau | NA | Sunday | 128.7157 | NA | 13627 | 26674 |
We sorted the table in descending order based on the Percentage of Daily Vaccinated Population, and Vermont tuned out to be the state with the most percentage of population vaccinated every day. This result resonates well with one of the conclusion we drew from the summary: Vermont has the highest fully-vaccinated population ratio among all states.
We were also interested in knowing on what day in the week people are the most willing to go get vaccinated in the week and concluded from that Saturday has the most vaccinations; this is likely because many people work on weekdays and are not able to go get their vaccination on such days. Another thing we found interesting from the table is that the states with higher rates of fully vaccinated population are democratic states.
Leaflet Map
Below is a map that shows the percentage of the population that is fully vaccinated in each state.